package com.my.hotel.mapper;

import com.my.hotel.entity.User;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface KhMapper {

    @Select("select * from tb_user u ,tb_user_role r where u.`id`=r.`user_id` and r.`role_id`=4 and u.username like '%${type}%'")
    public List<User> getUserList(@Param("type") String type);

}
